from utils.querys import queryhive


def getcatMovieData():
    catMovieData = queryhive('select * from dian_ying_shu_ju',[],'select')
    return catMovieData


def getmovieTypeCount():
    movieTypeCount = queryhive('select * from dian_ying_leixing_shu',[],'select')
    return movieTypeCount

def getboxTopMovie():
    boxTopMovie = queryhive('select * from piao_fang_top',[],'select')
    return boxTopMovie

def gettypeMaxBox():
    typeMaxBox = queryhive('select * from leixing_zuigao_piaofang',[],'select')
    return typeMaxBox

def getmcountryCount():
    mcountryCount = queryhive('select * from guo_jia_dian_ying_shu',[],'select')
    return mcountryCount

def getstarCategory():
    starCategory = queryhive('select * from mingxing_dengji',[],'select')
    return starCategory

def getperTypeBox():
    perTypeBox = queryhive('select * from mei_leixing_piaofang',[],'select')
    return perTypeBox

def getperTypeRate():
    perTypeRate = queryhive('select * from mei_leixing_pingfen',[],'select')
    return perTypeRate


def gettypeAvgTime():
    typeAvgTime = queryhive('select * from leixing_pingjun_shichang',[],'select')
    return typeAvgTime

def getmYearRate():
    mYearRate = queryhive('select * from nianfen_pingfen',[],'select')
    return mYearRate

def getmCountryRate():
    mCountryRate = queryhive('select * from guo_jia_pingfen',[],'select')
    return mCountryRate


def getmmTypeRate():
    mTypeRate = queryhive('select * from leixing_pingfen',[],'select')
    return mTypeRate


def getmmYearCount():
    mYearCount = queryhive('select * from nianfen_dianying_shu',[],'select')
    return mYearCount


def getmMonthCount():
    mMonthCount = queryhive('select * from yue_fen_dian_ying_shu',[],'select')
    return mMonthCount

def getmTimeCategory():
    mTimeCategory = queryhive('select * from shichang_fen_lei',[],'select')
    return mTimeCategory

def getmTypeAvgBox():
    mTypeAvgBox = queryhive('select * from leixing_pingjun_piaofang',[],'select')
    return mTypeAvgBox

def getmCountryAvgBox():
    mCountryAvgBox = queryhive('select * from guo_jia_ping_jun_piao_fang',[],'select')
    return mCountryAvgBox

def getmYearAvgBox():
    mYearAvgBox = queryhive('select * from nianfen_pingjun_piaofang',[],'select')
    return mYearAvgBox